<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page import="java.util.List" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="edu.sctu.User" %>
<%@ page import="edu.sctu.DataBase" %>
<%--
  Created by IntelliJ IDEA.
  User: ASUS
  Date: 2018/5/15
  Time: 16:01
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<
<style type="text/css">
table{
    border-collapse: collapse;
}
    td{
        border: 1px solid #000;
        padding: 10px;
    }

</style>

<%
//    class User{
//        int id;
//        String name;
//        String password;
//    }

//    List<User> userList=new ArrayList<User>();
//    //3+1
//    Class.forName("com.mysql.jdbc.Driver");
//    Connection connection=null;
//    Statement statement=null;
//    ResultSet resultSet=null;
//
//    connection= DriverManager.getConnection(
//            "jdbc:mysql://localhost:3306/sctu_javaweb_2018?serverTimezone=?",
//            "root",
//            "123456"
//
//    );
//
//    String sql="";
//    statement=connection.createStatement();
//    resultSet=statement.executeQuery(sql);
//
//    while (resultSet.next()){
//        int id=resultSet.getInt(1);
//        String name=resultSet.getString(2);
//        String password=resultSet.getString(3);
//
//        //封装
//        User user=new User();
//        user.setId(id);
//        user.setName(name);
//        user.setPassword(password);
//        userList.add(user);
//
//
//
//    }
//
//    connection.close();
//    statement.close();
//    resultSet.close();

//    DataBase dataBase=new DataBase();
//    List<User> userList=dataBase.getUserList();
//    //******
//    pageContext.setAttribute("userList",userList);
%>

<table>
    <tr>
        <td>编号</td>
        <td>用户名</td>
        <td>密码</td>
        <td>操作1</td>
        <td>操作2</td>
    </tr>

    <c:forEach var="user" items="${userList}">
        <tr>
            <td>${user.id}</td>
            <td>${user.name}</td>
            <td>${user.password}</td>
            <td></td>
            <td></td>
        </tr>
    </c:forEach>



</table>
</body>
</html>
